import pandas as pd

# Data provided by the user
data = {
    "Defect Type": [
        "ADI_particle_developed", "Array_peeling", "Cu_missing", "Other_peeling", "Partial_etch",
        "Pattern_fail", "PR_peeling", "Seam", "Reference", "Surface_particle", "Burried_particle",
        "Cu_diffuse", "Prelayer_defect_developed", "Void", "Residue", "Scratch"
    ],
    "Precision": [0.80, 0.82, 0.89, 0.88, 0.89, 0.83, 0.96, 0.81, 0.89, 0.88, 0.93, 0.86, 0.83, 0.93, 0.87, 0.93],
    "Recall": [0.78, 0.76, 0.85, 0.80, 0.88, 0.76, 0.96, 0.95, 0.92, 0.86, 0.90, 0.90, 0.83, 0.95, 0.87, 0.92],
    "F1-Score": [0.79, 0.79, 0.87, 0.83, 0.89, 0.79, 0.96, 0.88, 0.90, 0.87, 0.91, 0.88, 0.83, 0.94, 0.87, 0.92],
    "Count": [497, 66, 286, 290, 139, 106, 250, 169, 1892, 985, 1350, 709, 429, 1145, 1338, 1745]
}

# Creating DataFrame
df = pd.DataFrame(data)

# Saving to Excel file
excel_file_path = 'updated_defect_data_v3.xlsx'
df.to_excel(excel_file_path, index=False)
